I've been having this problem for a couple weeks now and have made no progress. I'm desperate for a solution.

Here's a link to my earlier thread:  https://social.technet.microsoft.com/Forums/office/en-US/a76746b5-230b-4c41-82bc-1653ccaf5fdb/microsoft-excel-has-stopped-working-error?forum=excel

Here's the situation.  I'm running Excel 2013 64 bit on Windows 8.1 with 16G RAM.

The spreadsheet uses PowerPivot.  The largest table has about 18,000 rows, so it's not very large.  It also uses VBA macros, but NO user forms.  There are a number of pivot tables and graphs (maybe 200 of each).  When running, the Task Manager shows it's using about 1.8G RAM.

When I open a spreadsheet, everything is working fine.  I make some changes and save it under a new name.  I close Excel and then restart Excel.  When I try to open the new version of the spreadsheet, Excel crashes (see below for the Event Viewer).  Actually, about half of the time the new version of the spreadsheet is fine and half of the time it crashes Excel.  Also, once a file causes Excel to crash, there's nothing I've found that will allow that file to reopen which is why I'm thinking maybe the file is getting corrupted when it's being saved.

I've tried a number of things, and so far nothing's fixed the problem.  The things I've tried include:

 - repaired Office -- no improvement

 - installed 32-bit version of Excel (couldn't open any of the files)

 - check to make sure Windows is updated

 - uninstall and reinstall Excel 64 bit -- no improvement

 - save the file without macros and then copy/paste the macros back into the new file -- no improvement

 - running Excel in safe mode -- still crashes with the 'bad' files

 - running Windows with a clean boot -- no improvement

 - deleted some of the pivot tables and graphs to reduce the file size -- no improvement

 - recompiled the Project and Disable Compile on Demand -- seemed to help, but after about 4 or 5 file saves, it again crashed Excel

In summary, the spreadsheet works fine.  However, randomly on saving the file something happens and that version of the file can't be reopened in Excel, so all the work is lost.

Please help me find a fix to this problem.

Thanks, Jean

Here's the information from the Event Viewer:

Faulting application name: EXCEL.EXE, version: 15.0.4727.1000, time stamp: 0x555224da
Faulting module name: VBE7.DLL, version: 0.0.0.0, time stamp: 0x54d13f31
Exception code: 0xc0000005
Fault offset: 0x000000000013c591
Faulting process id: 0x1cdc
Faulting application start time: 0x01d0b5ac8189d898
Faulting application path: C:\Program Files\Microsoft Office 15\root\office15\EXCEL.EXE
Faulting module path: C:\Program Files\Common Files\Microsoft Shared\VBA\VBA7.1\VBE7.DLL
Report Id: d325224a-219f-11e5-8297-7429afd8d046
Faulting package full name:
Faulting package-relative application ID:

Hi Jeans,

I provided several methods about troubleshooting your issue several days ago, you had tried all of them but they didnt work for you.

Depending on your event log messages, your issue is about VBE7.DLL in your computer. This DLL file is a common file in operating system, it's not only used for Excel but also for other programs.

I suggest you send your excel file to another users computer, if it works fine please copy the VBE7.DLL file from that healthy computer to your computer and re-register this DLL file.

The path of storing VBE7.DLL file:

C:\Program Files\Common Files\Microsoft Shared\VBA\VBA7.1\VBE7.DLL

There is another method, you can try to upgrade .NET Framework to 4.0 version and above.

Please try these methods and let me know if they work for you.

I'm glad to help and follow up your reply.

Regards,

Emi Zhang
TechNet Community Su

Emi, Thanks for your reply.

I didn't think I had another PC I could try the file on, but my old computer still had a version of Excel.  (I replaced that computer about 2 months ago with the PC that's giving me all the trouble.)  Anyway, the Excel file seems to be working fine on the old PC -- I'm able to make changes and save the file and no file corruption has happened yet after multiple changes.

So I copied the VBE7.dll file from the old PC to the new PC.  (By the way, the file path on both PCs is:  C:\Program Files\Microsoft Office 15\root\vfs\ProgramFilesCommonX64\Microsoft Shared\VBA\VBA7.1 )  I'm not sure why the path is different from the path in the event log.

I tried making changes to the Excel file on the new PC and got the same error, so it seems to be a PC-specific problem.

Here's the event log:

Faulting application name: EXCEL.EXE, version: 15.0.4727.1000, time stamp: 0x555224da
Faulting module name: VBE7.DLL, version: 0.0.0.0, time stamp: 0x54d13f31
Exception code: 0xc0000005
Fault offset: 0x000000000013edcd
Faulting process id: 0x958
Faulting application start time: 0x01d0b8c3409516d4
Faulting application path: C:\Program Files\Microsoft Office 15\root\office15\EXCEL.EXE
Faulting module path: C:\Program Files\Common Files\Microsoft Shared\VBA\VBA7.1\VBE7.DLL
Report Id: 9268bd57-24b6-11e5-829c-7429afd8d046
Faulting package full name:
Faulting package-relative application ID:

Thanks for any new suggestions you have.

Jean